/*
 Navicat Premium Data Transfer

 Source Server         : local
 Source Server Type    : MySQL
 Source Server Version : 50729
 Source Host           : localhost:3306
 Source Schema         : ginadmin

 Target Server Type    : MySQL
 Target Server Version : 50729
 File Encoding         : 65001

 Date: 11/07/2021 16:46:25
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for tbl_menu
-- ----------------------------
DROP TABLE IF EXISTS `tbl_menu`;
CREATE TABLE `tbl_menu` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `deleted_at` datetime DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `url` varchar(255) DEFAULT NULL,
  `parent_id` int(10) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `idx_tbl_menu_deleted_at` (`deleted_at`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of tbl_menu
-- ----------------------------
BEGIN;
INSERT INTO `tbl_menu` VALUES (1, '2021-07-02 00:25:01', '2021-07-02 00:25:01', NULL, '系统管理', '', 0);
INSERT INTO `tbl_menu` VALUES (2, '2021-07-02 00:25:01', '2021-07-02 00:25:01', NULL, '机构管理', '/view/org-list.html', 1);
INSERT INTO `tbl_menu` VALUES (3, '2021-07-02 00:25:02', '2021-07-02 00:25:02', NULL, '用户管理', '/view/user-list.html', 1);
INSERT INTO `tbl_menu` VALUES (4, '2021-07-02 00:25:02', '2021-07-02 00:25:02', NULL, '角色管理', '/view/role-list.html', 1);
INSERT INTO `tbl_menu` VALUES (5, '2021-07-02 00:25:02', '2021-07-02 00:25:02', NULL, '菜单管理', '/view/menu-list.html', 1);
INSERT INTO `tbl_menu` VALUES (12, '2021-07-11 05:44:15', '2021-07-11 05:44:15', '2021-07-11 05:51:43', '', '', 0);
INSERT INTO `tbl_menu` VALUES (13, '2021-07-11 06:07:12', '2021-07-11 06:07:12', '2021-07-11 06:07:16', '3424', '的说法发', 0);
COMMIT;

-- ----------------------------
-- Table structure for tbl_organization
-- ----------------------------
DROP TABLE IF EXISTS `tbl_organization`;
CREATE TABLE `tbl_organization` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `deleted_at` datetime DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `parent_id` int(10) unsigned DEFAULT NULL,
  `parent_name` varchar(255) DEFAULT NULL,
  `ancestors` varchar(255) DEFAULT NULL,
  `order_num` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `idx_tbl_organization_deleted_at` (`deleted_at`)
) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of tbl_organization
-- ----------------------------
BEGIN;
INSERT INTO `tbl_organization` VALUES (1, '2021-07-09 08:06:35', '2021-07-10 14:02:55', NULL, 'ginadmin平台', 0, NULL, '0', 0);
INSERT INTO `tbl_organization` VALUES (2, '2021-07-09 08:08:02', '2021-07-09 08:08:07', NULL, '深圳总公司', 1, '平台', '0,1', 1);
INSERT INTO `tbl_organization` VALUES (3, '2021-07-09 08:10:59', '2021-07-09 08:11:03', NULL, '长沙分公司', 1, '平台', '0,1', 2);
INSERT INTO `tbl_organization` VALUES (4, '2021-07-09 08:11:52', '2021-07-09 08:11:56', NULL, '研发部门', 2, '深圳总公司', '0,1,2', 1);
INSERT INTO `tbl_organization` VALUES (5, '2021-07-09 08:13:48', '2021-07-09 08:13:51', NULL, '市场部门', 2, '深圳总公司', '0,1,2', 2);
INSERT INTO `tbl_organization` VALUES (6, '2021-07-09 08:13:48', '2021-07-09 08:13:51', NULL, '测试部门', 2, '深圳总公司', '0,1,2', 3);
INSERT INTO `tbl_organization` VALUES (7, '2021-07-09 08:13:48', '2021-07-09 08:13:51', NULL, '财务部门', 2, '深圳总公司', '0,1,2', 4);
INSERT INTO `tbl_organization` VALUES (8, '2021-07-09 08:13:48', '2021-07-09 08:13:51', NULL, '运维部门', 2, '深圳总公司', '0,1,2', 5);
INSERT INTO `tbl_organization` VALUES (9, '2021-07-09 08:13:48', '2021-07-09 08:13:51', NULL, '市场部门', 3, '长沙总公司', '0,1,3', 1);
INSERT INTO `tbl_organization` VALUES (10, '2021-07-09 08:13:48', '2021-07-09 08:13:51', NULL, '财务部门', 3, '长沙总公司', '0,1,3', 2);
INSERT INTO `tbl_organization` VALUES (19, '2021-07-10 15:47:07', '2021-07-10 15:47:07', NULL, '天津总公司', 1, 'ginadmin平台', '0,1', 0);
INSERT INTO `tbl_organization` VALUES (20, '2021-07-10 15:47:20', '2021-07-10 23:43:27', NULL, '南开分公司', 19, '天津总公司', '0,1,19', 0);
INSERT INTO `tbl_organization` VALUES (21, '2021-07-10 23:42:26', '2021-07-10 23:42:26', NULL, '长江道', 20, '南开分公司', '0,1,19,20', 0);
COMMIT;

-- ----------------------------
-- Table structure for tbl_role
-- ----------------------------
DROP TABLE IF EXISTS `tbl_role`;
CREATE TABLE `tbl_role` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `deleted_at` datetime DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `auth` varchar(255) DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `idx_tbl_role_deleted_at` (`deleted_at`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of tbl_role
-- ----------------------------
BEGIN;
INSERT INTO `tbl_role` VALUES (1, '2021-07-11 00:05:47', '2021-07-11 00:05:47', NULL, '系统管理员', '1,2,3,4,5,9,10,11', 1);
COMMIT;

-- ----------------------------
-- Table structure for tbl_user
-- ----------------------------
DROP TABLE IF EXISTS `tbl_user`;
CREATE TABLE `tbl_user` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `deleted_at` datetime DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `password` varchar(255) DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  `role` varchar(255) DEFAULT NULL,
  `roleid` int(11) DEFAULT NULL,
  `error_num` int(11) DEFAULT NULL,
  `user_name` varchar(255) DEFAULT NULL,
  `phone` varchar(255) DEFAULT NULL,
  `rem` varchar(255) DEFAULT NULL,
  `org_id` int(10) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `idx_tbl_user_deleted_at` (`deleted_at`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of tbl_user
-- ----------------------------
BEGIN;
INSERT INTO `tbl_user` VALUES (1, '2021-06-30 23:52:45', '2021-06-30 23:52:45', NULL, 'admin', '123456', 0, '超级管理员', 1, 0, 'admin', NULL, NULL, 1);
INSERT INTO `tbl_user` VALUES (3, '2021-07-11 05:23:21', '2021-07-11 05:23:21', NULL, '王佳', '111111', 0, '系统管理员', 1, 0, 'wangjia', '', '', 1);
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
